2014-03-17 - 11907 - Spec - Create Query off COPA lower level #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
11907 - Create Query off COPA lower level
Purpose
Create a BEx query off the COPA lower level infocube to get scorecard information in BPD(BW 7.3 Development).
Admin Info
Purpose
|
To Create BEx Query on COPA Layer 1 Cube
|
Requested By
|
Jack Mehltretter
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
03/17/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZIC_COPA_Q001
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
Attached with related release notes.
Functional Requirement
Need to create the BEx query in BPD(BW 7.3 Development) system and transport it to BPQ(BW 7.3 Quality) and BPP(BW 7.3 Production).
Solution Summary
1. Need to create a BEx Query in BPD.
2. Need to maintain required Characteristics, Key Figures and other query properties as per the requirement.
3. Check the BEx query for QA Standards.
4. Unit test and transport it to BPQ.
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1.
|
Check the BEx query against NEC Standard BEx checklist.
|
BEx query should pass all test cases as per NEC standard checklist.
|
2
|
Test the BEx query functionality in BPQ.
|
Query should be successfully validated in BPQ.
|
Solution Details
1. Need to create a BEx Query in BPD(BW 7.3 Development) as per standard naming convention.
2. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
3. Check the BEx query for QA Standards against the NEC standard checklist and for consistent data in BPQ system.
4. Unit Test the query and then transport it to BPQ for further detailed testing.
Issues
None